/****** Object:  StoredProcedure dbo.sp_asi_GetFullName  ******/

-- =============================================
-- This stored procedure calculates FullName based on the input parameters.
-- Input parameters are FirstName, MiddleName, LastName, Prefix, Suffix, Title, Designation,
-- Informal. Output parameter is FullName.
-- By default, FullName is calculated to
-- @Prefix + ' ' + @FirstName + ' ' + @MiddleName + ' ' + @LastName
--        + ', ' + @Suffix + ', ' + @Designation
-- =============================================
CREATE PROCEDURE dbo.sp_asi_GetFullName
    @FirstName varchar(20) = NULL,
    @MiddleName varchar(20) = NULL,
    @LastName varchar(30) = NULL,
    @Prefix varchar(25) = NULL,
    @Suffix varchar(10) = NULL,
    @Designation varchar(20) = NULL,
    @Title varchar(80) = NULL,
    @Informal varchar(20) = NULL,
    @FullName varchar(70) OUTPUT
AS
BEGIN
    SET @FullName = dbo.fn_asi_GetFullName(@FirstName,@MiddleName,@LastName,@Prefix,@Suffix,@Designation,@Title,@Informal)
    SELECT @FullName as FullName

END

GO
GRANT EXECUTE ON  [dbo].[sp_asi_GetFullName] TO [IMIS]
GO